<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/li563868273/article/details/51254907"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"Mysql执行查询的原理 - lizhao007"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>Mysql执行查询的原理 - lizhao007 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
            <script type="application/ld+json">{"@context":"https:\/\/ziyuan.baidu.com\/contexts\/cambrian.jsonld","@id":"https:\/\/blog.csdn.net\/li563868273\/article\/details\/51254907","appid":"1563894916825412","title":"Mysql\u6267\u884c\u67e5\u8be2\u7684\u539f\u7406 - lizhao007","images":["https:\/\/img-blog.csdn.net\/2018070416523162?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpNTYzODY4Mjcz\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70"],"pubDate":"2019-08-09T15:10:02"}</script>
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin-blackboard/skin-blackboard-1340d63bd5.min.css">
        <script type="text/javascript">
        var username = "li563868273";
        var blog_address = "https://blog.csdn.net/li563868273";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/li563868273/article/details/51254907"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin-blackboard";
        // 收藏所需数据
        var articleTitle = "Mysql执行查询的原理";
        var articleDesc = "MySQL执行路径从图中可以看出基本步骤为:1.客户端发送一条查询给服务器。2.服务器先检查查询缓存，如果命中了缓存，则立刻返回存储在缓存中的结果。否则进入下一阶段。3。服务器端进行SQL解析，预处理，再由优化器生成对应的执行计划4。MySql根据优化器生成的执行计划，调用存储引擎的API执行查询。5。返回结果给客户端。MySQL客户端/服务器通信协议MySQL客户端和服务器";
        // 第四范式所需数据
        var articleTitles = "Mysql执行查询的原理 - lizhao007";
        
        var nickName = "li563868273";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/li563868273/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/li563868273/article/details/51254907";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">Mysql执行查询的原理</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2016年04月26日 22:32:52</span>
                    <a class="follow-nickName" href="https://me.csdn.net/li563868273" target="_blank">li563868273</a>
                    <span class="read-count">阅读数 6778</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/li563868273/article/details/51254907"> https://blog.csdn.net/li563868273/article/details/51254907</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <h2 id="mysql执行路径">MySQL执行路径</h2>

<p><img src="https://img-blog.csdn.net/20160426211512664" alt="Mysql执行路径" title=""> <br>
从图中可以看出基本步骤为: <br>
1.客户端发送一条查询给服务器。 <br>
2.服务器先检查查询缓存，如果命中了缓存，则立刻返回存储在缓存中的结果。否则进入下一阶段。 <br>
3。服务器端进行SQL解析，预处理，再由优化器生成对应的执行计划 <br>
4。MySql根据优化器生成的执行计划，调用存储引擎的API执行查询。 <br>
5。返回结果给客户端。</p>



<h2 id="mysql客户端服务器通信协议">MySQL客户端/服务器通信协议</h2>

<p>MySQL客户端和服务器之间的通信协议是“半双工”的，这意味着，在任何野时刻，要么是由服务器向客户端发送数据，要么是客户端向服务器发送数据，这两个动作不能同时执行。所以，我们无法也无须将也消息切成小块独立来发送。</p>

<p>这种协议让MySQL通信简单快速，但是也从很多地方限制了MySQL。一端开始发送消息，另一端要接受完整个消息才能响应它。这就像来回抛球的游戏：在任何时刻，只有一个人能控制球，而且只有控球的人才能将球发回去。</p>

<p>相反的，一般服务器响应给用户的数据通常很多，由多个数据包组成。当服务器开始响应客户端请求时，客户端必须完整地接受整个返回结果，而不能简单地只去前面这个结果，然后让服务器停止发送。这就是为什么要加Limit</p>



<h3 id="查询状态">查询状态</h3>

<p>对于一个MySQL连接，或者说一个线程，任何时刻都有一个状态，该状态表示了MySQL当前正在做什么，最简单是使用SHOW FULLPROCESSLIST命令。在一个查询的生命周期中，状态会变化很多次。MySQL官方手册对这些状态值的含义最权威的解释: <br>
Sleep:线程等待客户端发送新的请求。 <br>
Query:线程正在执行查询或者正在将结果发送给客户端。 <br>
Locked:线程在等待表锁。等待行锁时不会出现。 <br>
Analyzing and statistics:线程正在收集存储引擎统计信息，并生成查询计划。 <br>
Sorting result:线程正在对结果排序。</p>



<h2 id="查询缓存">查询缓存</h2>

<p>在解析SQL语句之前，如果查询缓存是打开的，MySql会首先检查这个查询是否命中缓存中的数据。如果当前的查询恰好命中了查询缓存，那么在返回查询结果之前MySQL会检查一次用户权限，如果权限没问题就会返回，这种情况下查询不会被解析，不用生成执行计划，不会被执行。</p>



<h3 id="查询优化处理">查询优化处理</h3>

<p>在查询缓存的下一步是解析SQL,预处理，优化SQL执行计划。这个过程中任何错误都可能终止查询。</p>



<h4 id="语法解析和预处理">语法解析和预处理</h4>

<p>首先MySQL通过关键字将SQL语句进行解析，并生成一颗对应的”解析树”。MySQL解析器将使用MySQL语法规则和解析查询。 <br>
预处理会根据MySQL规则进一步检查解析树是否合法。</p>



<h4 id="查询优化">查询优化</h4>

<p>如果语法树是被认为是合法的，现在就会通过优化器转化为执行计划。 <br>
MysQL使用基于成本的优化器，它将尝试预测一个查询使用某种执行计划时的成本，并选择其中成本最小的一个。 <br>
有很多原因会导致MySQL优化器会选择错误执行计划。 <br>
1。统计信息不准确。 <br>
2。执行计划中的成本估算不等同于实际执行的成本。 <br>
3。MySQL的最优可能和你想的不一样 <br>
4。MySQL不考虑其他并发执行的查询 <br>
MySQL可以支持的优化类型: <br>
1。重新定义关联表的顺序 <br>
2。外连接转换为内连接 <br>
3。使用等价变换规则 <br>
4。优化COUNT(),MIN和MAX()——利用索引优化 <br>
5。预估转换为常数表达式 <br>
6。覆盖索引扫描 <br>
7。子查询优化 <br>
8。提前终止查询–LIMIT <br>
9。等值传播 <br>
10。列表in()的比较–不是简单的or，将其排序并用二分查找的方式来确定列表中的值是否满足、</p>



<h1 id="更多交流请扫我的技术公众号">更多交流请扫我的技术公众号</h1>

<p><img src="https://img-blog.csdn.net/2018070416523162?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpNTYzODY4Mjcz/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="我的技术公众号" title=""></p>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/li563868273/article/details/51254907","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/li563868273/article/details/51254907","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-386","con":",,"}' data-track-click='{"mod":"kp_popu_58-386","con":",,"}' data-report-view='{"mod":"kp_popu_58-386","keyword":""}' data-report-click='{"mod":"kp_popu_58-386","keyword":""}'><div style="width:100%;background:#fff;">
<script type="text/javascript" src="//rabc1.iteye.com/production/resource/web/6xwm4l.js?lg=ydmpioh"></script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="51254907">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sinat_32176267/article/details/83280206","strategy":"BlogCommendFromBaidu","index":"0"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sinat_32176267/article/details/83280206","strategy":"BlogCommendFromBaidu","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sinat_32176267/article/details/83280206" target="_blank" title="Mysql查询语句执行过程及运行原理">
		<h4 class="text-truncate oneline">
				<em>Mysql</em><em>查询</em>语句<em>执行</em>过程及运行<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-22</span>
				<span class="read-num hover-hide">
					阅读数 
					3020</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sinat_32176267/article/details/83280206" target="_blank" title="Mysql查询语句执行过程及运行原理">
				<span class="desc oneline">Mysql查询语句执行原理数据库查询语句如何执行？DML语句首先进行语法分析，对使用sql表示的查询进行语法分析，生成查询语法分析树。	语义检查：检查sql中所涉及的对象以及是否在数据库中存在，用户是...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sinat_32176267">来自：	<span class="blog_title"> sinat_32176267的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392287464","strategy":"BlogCommendFromBaidu","index":"1"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392287464","strategy":"BlogCommendFromBaidu","index":"1"}'>
	<a href="https://bbs.csdn.net/topics/392287464" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>带条件子<em>查询</em>的<em>执行</em>顺序是怎样的		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">11-16</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">SELECT ( SELECT count(id) FROM project_distribute WHERE net_status = '内网' ) AS intranet, ( SELECT co</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/391980758","strategy":"BlogCommendFromBaidu","index":"2"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/391980758","strategy":"BlogCommendFromBaidu","index":"2"}'>
	<a href="https://bbs.csdn.net/topics/391980758" target="_blank">
		<h4 class="text-truncate oneline">
				求推荐<em>mysql</em>底层<em>原理</em>书籍		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">07-07</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">关于mysql优化的底层原理，现在能找到的都是只言片语的介绍，求推荐能系统介绍mysql底层原理的书籍或者文章，谢谢。 举个例子，说明下想学习的内容： 如下数据表，id，品牌name，品牌分类id +</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/tongdanping/article/details/79878302","strategy":"BlogCommendFromBaidu","index":"3"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/tongdanping/article/details/79878302","strategy":"BlogCommendFromBaidu","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/tongdanping/article/details/79878302" target="_blank" title="深入理解MySQL索引原理和实现——为什么索引可以加速查询？">
		<h4 class="text-truncate oneline">
				深入理解<em>MySQL</em>索引<em>原理</em>和实现——为什么索引可以加速<em>查询</em>？		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-12</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/tongdanping/article/details/79878302" target="_blank" title="深入理解MySQL索引原理和实现——为什么索引可以加速查询？">
				<span class="desc oneline">说到索引，很多人都知道“索引是一个排序的列表，在这个列表中存储着索引的值和包含这个值的数据所在行的物理地址，在数据十分庞大的时候，索引可以大大加快查询的速度，这是因为使用索引后可以不用扫描全表来定位某...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/tongdanping">来自：	<span class="blog_title"> tongdanping的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/ignorewho/article/details/83050901","strategy":"BlogCommendFromBaidu","index":"4"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/ignorewho/article/details/83050901","strategy":"BlogCommendFromBaidu","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ignorewho/article/details/83050901" target="_blank" title="mysql-查询原理">
		<h4 class="text-truncate oneline">
				<em>mysql</em>-<em>查询</em><em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-14</span>
				<span class="read-num hover-hide">
					阅读数 
					214</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ignorewho/article/details/83050901" target="_blank" title="mysql-查询原理">
				<span class="desc oneline">mysql是如何执行查询?1.客户端将查询发送到服务器2.服务器检查查询缓存，如果找到了，就从缓存中返回结果，否则进行下一步3.服务器解析，预处理和优化查询，生成执行计划4.执行引擎调用存储引擎api...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ignorewho">来自：	<span class="blog_title"> ignorewho的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392359805","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392359805","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<a href="https://bbs.csdn.net/topics/392359805" target="_blank">
		<h4 class="text-truncate oneline">
				数据库小白求教数据库<em>查询</em>的<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-16</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">有个问题我一直不明白 我们在写sql的时候在后面加个where条件 比如select * from student where name='zhangsan' 这里name字段即使没有加索引数据库也能</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/strivenoend/article/details/83153053","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/strivenoend/article/details/83153053","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/strivenoend/article/details/83153053" target="_blank" title="---mysql查询">
		<h4 class="text-truncate oneline">
				---<em>mysql</em><em>查询</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-18</span>
				<span class="read-num hover-hide">
					阅读数 
					237</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/strivenoend/article/details/83153053" target="_blank" title="---mysql查询">
				<span class="desc oneline">mysql查询关系数据库对数据操作的运算---关系运算----sql语言关系数据库对数据的操作---关系运算sql是关系数据库对数据的操作的一种封装的结构化查询语言，即sql是对关系运算封装的一门结构...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/strivenoend">来自：	<span class="blog_title"> 估计我以后要嫁给程序还有API文档嗯~ o(*￣▽￣*)o</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/chaoyue1861/article/details/80468773","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/chaoyue1861/article/details/80468773","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chaoyue1861/article/details/80468773" target="_blank" title="一、MySQL原理">
		<h4 class="text-truncate oneline">
				一、<em>MySQL</em><em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-27</span>
				<span class="read-num hover-hide">
					阅读数 
					968</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chaoyue1861/article/details/80468773" target="_blank" title="一、MySQL原理">
				<span class="desc oneline">收到</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chaoyue1861">来自：	<span class="blog_title"> 奔跑8蜗牛</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_33739523/article/details/85658303","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_33739523/article/details/85658303","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33739523/article/details/85658303" target="_blank" title="MySQL运行原理与基础架构">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>运行<em>原理</em>与基础架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-24</span>
				<span class="read-num hover-hide">
					阅读数 
					29</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33739523/article/details/85658303" target="_blank" title="MySQL运行原理与基础架构">
				<span class="desc oneline">1.MySQL基础MySQL是一个开放源代码的关系数据库管理系统。原开发者为瑞典的MySQLAB公司，最早是在2001年MySQL3.23进入到管理员的视野并在之后获得广泛的应用。2008年MySQL...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33739523">来自：	<span class="blog_title"> weixin_33739523的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/hsd2012/article/details/51526733","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/hsd2012/article/details/51526733","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hsd2012/article/details/51526733" target="_blank" title="MySQL查询优化器工作原理解析">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>查询</em>优化器工作<em>原理</em>解析		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hsd2012/article/details/51526733" target="_blank" title="MySQL查询优化器工作原理解析">
				<span class="desc oneline">手册上MYSQL查询优化器概述；个人对MySQL优化器的理解；分析优化器优化过程中的信息；调节MySQL优化器的优化等...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hsd2012">来自：	<span class="blog_title"> hsd2012的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/GitChat/article/details/78787837","strategy":"BlogCommendFromBaidu","index":"10"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/GitChat/article/details/78787837","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/GitChat/article/details/78787837" target="_blank" title="深入理解 MySQL 底层实现">
		<h4 class="text-truncate oneline">
				深入理解 <em>MySQL</em> 底层实现		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-13</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/GitChat/article/details/78787837" target="_blank" title="深入理解 MySQL 底层实现">
				<span class="desc oneline">本文来自作者 默默 在 GitChat 上分享「深入理解MySQL底层实现」，「阅读原文」查看交流实录。「文末高能」编辑|哈比MySQL的常用引擎1.InnoDBInnoDB的存储文件有两个，后缀名分...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/GitChat">来自：	<span class="blog_title"> GitChat技术杂谈</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zk_haha09/article/details/48417027","strategy":"BlogCommendFromBaidu","index":"11"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zk_haha09/article/details/48417027","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zk_haha09/article/details/48417027" target="_blank" title="MySQL数据库查询步骤和缓存原理">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库<em>查询</em>步骤和缓存<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-13</span>
				<span class="read-num hover-hide">
					阅读数 
					1446</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zk_haha09/article/details/48417027" target="_blank" title="MySQL数据库查询步骤和缓存原理">
				<span class="desc oneline">我们知道，数据库的查询功能是我们经常用到的，那么MySQL数据库是怎样进行查询的呢？本文我们就来介绍一下MySQL数据库的查询步骤以及缓存原理，接下来就让我们来一起了解一下这一部分内容。当MySQL收...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zk_haha09">来自：	<span class="blog_title"> zk_haha09的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/iefreer/article/details/15815455","strategy":"BlogCommendFromBaidu","index":"12"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/iefreer/article/details/15815455","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iefreer/article/details/15815455" target="_blank" title="MySQL:索引工作原理">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>:索引工作<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-15</span>
				<span class="read-num hover-hide">
					阅读数 
					9万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iefreer/article/details/15815455" target="_blank" title="MySQL:索引工作原理">
				<span class="desc oneline">MySQL索引原理详解：为什么需要索引（Why），什么是索引（What），什么时候用索引（When），索引怎么工作的（How）...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iefreer">来自：	<span class="blog_title"> 陈小峰（iefreer）的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qiuyepiaoling/article/details/7464718","strategy":"BlogCommendFromBaidu","index":"13"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qiuyepiaoling/article/details/7464718","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qiuyepiaoling/article/details/7464718" target="_blank" title="MySQL 中 GROUP BY 基本实现原理">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 中 GROUP BY 基本实现<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-16</span>
				<span class="read-num hover-hide">
					阅读数 
					523</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qiuyepiaoling/article/details/7464718" target="_blank" title="MySQL 中 GROUP BY 基本实现原理">
				<span class="desc oneline">转自简朝阳:http://isky000.com/database/mysql_group_by_implement之前连着写了几篇关于MySQL中常用操作的一些基本实现原理，如，MySQLORDER...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qiuyepiaoling">来自：	<span class="blog_title"> qiuyepiaoling的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/isoleo/article/details/52595637","strategy":"BlogCommendFromBaidu","index":"14"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/isoleo/article/details/52595637","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/isoleo/article/details/52595637" target="_blank" title="Mysql 工作原理">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 工作<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-20</span>
				<span class="read-num hover-hide">
					阅读数 
					3169</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/isoleo/article/details/52595637" target="_blank" title="Mysql 工作原理">
				<span class="desc oneline">Mysql工作原理下面先来一张经典的图：  上面的图就是mysql的内部架构，可以清楚的看到Mysql是由SQL接口，解析器，优化器，缓存，存储引擎组成的。 -+-------------------...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/isoleo">来自：	<span class="blog_title"> 李晓蒙的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u011479200/article/details/78513632","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u011479200/article/details/78513632","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011479200/article/details/78513632" target="_blank" title="Mysql| 使用通配符进行模糊查询(like,%,_)">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>| 使用通配符进行模糊<em>查询</em>(like,%,_)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-12</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011479200/article/details/78513632" target="_blank" title="Mysql| 使用通配符进行模糊查询(like,%,_)">
				<span class="desc oneline">通配符的分类:%百分号通配符:表示任何字符出现任意次数(可以是0次)._下划线通配符:表示只能匹配单个字符,不能多也不能少,就是一个字符.like操作符:LIKE作用是指示mysql后面的搜索模式是利...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011479200">来自：	<span class="blog_title"> YvesHe的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_614","dest":"https://download.csdn.net/download/hello188988/8813855","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_614","dest":"https://download.csdn.net/download/hello188988/8813855","strategy":"BlogCommendFromBaidu","index":"16"}'>
		<a href="https://download.csdn.net/download/hello188988/8813855" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>mysql</em>之SQL<em>查询</em><em>原理</em>					</h4>
					<span class="data float-right">06-16</span>
				</div>
				<div class="desc oneline">
						一句简单的sql语句背后，mysql进行了很多临时表操作。本文档描述了sql中各关键字（FROM, JOIN, WHERE ,ORDER BY等）的执行顺序，便于深入理解sql执行原理。				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010688637/article/details/56833259","strategy":"BlogCommendFromBaidu","index":"17"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010688637/article/details/56833259","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010688637/article/details/56833259" target="_blank" title="数据库查询select原理">
		<h4 class="text-truncate oneline">
				数据库<em>查询</em>select<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-24</span>
				<span class="read-num hover-hide">
					阅读数 
					539</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010688637/article/details/56833259" target="_blank" title="数据库查询select原理">
				<span class="desc oneline">数据库查询select原理    做为B/S架构的开发人员,总是离不开数据库,一般开发员只会应用SQL的四条经典语句:select,insert,delete,update。但是我从来没有研究过它们的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010688637">来自：	<span class="blog_title"> Loser的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_34246546/article/details/80758085","strategy":"BlogCommendFromBaidu","index":"18"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_34246546/article/details/80758085","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34246546/article/details/80758085" target="_blank" title="mysql查询机制(mysql学习笔记)">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>查询</em>机制(<em>mysql</em>学习笔记)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-21</span>
				<span class="read-num hover-hide">
					阅读数 
					298</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34246546/article/details/80758085" target="_blank" title="mysql查询机制(mysql学习笔记)">
				<span class="desc oneline">每当查询被发送到服务端时，服务器在执行语句之前将会进行下面的检查：1，用户是否有权限执行该语句2, 用户是否有权限访问目标数据3，语句的语法是否正确如果查询语句通过了这三个测试，就会被传递给查询优化器...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34246546">来自：	<span class="blog_title"> 拾荒者</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/nijimin100/article/details/7924999","strategy":"BlogCommendFromBaidu","index":"19"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/nijimin100/article/details/7924999","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/nijimin100/article/details/7924999" target="_blank" title="数据库中 in 和 exist 区别">
		<h4 class="text-truncate oneline">
				数据库中 in 和 exist 区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-30</span>
				<span class="read-num hover-hide">
					阅读数 
					729</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/nijimin100/article/details/7924999" target="_blank" title="数据库中 in 和 exist 区别">
				<span class="desc oneline">select*fromAwhereidin(selectidfromB)以上查询使用了in语句,in()只执行一次,它查出B表中的所有id字段并缓存起来.之后,检查A表的id是否与B表中的id相等,如...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/nijimin100">来自：	<span class="blog_title"> nijimin100的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30955341/article/details/98516604","strategy":"BlogCommendFromBaidu","index":"20"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30955341/article/details/98516604","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30955341/article/details/98516604" target="_blank" title="MySQL  in型子查询陷阱">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>  in型子<em>查询</em>陷阱		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-12</span>
				<span class="read-num hover-hide">
					阅读数 
					4</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30955341/article/details/98516604" target="_blank" title="MySQL  in型子查询陷阱">
				<span class="desc oneline">现在有两个表，table1和table2，table1有1千万数据（id主键索引），table2有三条数据（uid字段3,5,7）；select*fromtable1whereidin(selectu...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30955341">来自：	<span class="blog_title"> weixin_30955341的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/nangeali/article/details/74079260","strategy":"BlogCommendFromBaidu","index":"21"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/nangeali/article/details/74079260","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/nangeali/article/details/74079260" target="_blank" title="MySQL带IN关键字的查询">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>带IN关键字的<em>查询</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-01</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/nangeali/article/details/74079260" target="_blank" title="MySQL带IN关键字的查询">
				<span class="desc oneline">IN关键字，用于判断某个记录的值，是否在指定的集合中如果字段的值在集合中，则满足条件，该字段所在的记录将会被查询出来。SELECT*|字段名1，字段名2，……FROM表名WHERE字段名[NOT]IN...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/nangeali">来自：	<span class="blog_title"> 天高任鸟飞</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_32998153/article/details/81747643","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_32998153/article/details/81747643","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_32998153/article/details/81747643" target="_blank" title="Sql语句的执行原理-MySQL">
		<h4 class="text-truncate oneline">
				Sql语句的<em>执行</em><em>原理</em>-<em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-16</span>
				<span class="read-num hover-hide">
					阅读数 
					1763</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_32998153/article/details/81747643" target="_blank" title="Sql语句的执行原理-MySQL">
				<span class="desc oneline">第一步：应用程序把查询SQL语句发送给服务器端执行。我们在数据库层执行SQL语句时，应用程序会连接到相应的数据库服务器，把SQL语句发送给服务器处理。第二步：查询缓存服务器在解析一个查询语句之前，如果...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_32998153">来自：	<span class="blog_title"> qq_32998153的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/pangbianlaogu/article/details/80262192","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/pangbianlaogu/article/details/80262192","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/pangbianlaogu/article/details/80262192" target="_blank" title="MySQL语法执行工作原理">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>语法<em>执行</em>工作<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-10</span>
				<span class="read-num hover-hide">
					阅读数 
					242</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/pangbianlaogu/article/details/80262192" target="_blank" title="MySQL语法执行工作原理">
				<span class="desc oneline">目录一、MySQL语法执行工作原理1.1案例二、从MySQL语法执行原理谈性能测试2.1混合场景测试以及长时间稳定性测试的必要性2.2数据库缓存设置大小和性能的关系三、数据库服务器缓存配置策略四、各数...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/pangbianlaogu">来自：	<span class="blog_title"> pangbianlaogu的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/crazzy_lp/article/details/84684072","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/crazzy_lp/article/details/84684072","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/crazzy_lp/article/details/84684072" target="_blank" title="mysql中SQL执行过程详解">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中SQL<em>执行</em>过程详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-06</span>
				<span class="read-num hover-hide">
					阅读数 
					192</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/crazzy_lp/article/details/84684072" target="_blank" title="mysql中SQL执行过程详解">
				<span class="desc oneline">  mysql执行一个查询的过程，到底做了些什么：客户端发送一条查询给服务器；服务器先检查查询缓存，如果命中了缓存，则立刻返回存储在缓存中的结果。否则进入下一阶段。服务器段进行SQL解析、预处理，在优...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/crazzy_lp">来自：	<span class="blog_title"> crazzy_lp的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Gpwner/article/details/51555102","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Gpwner/article/details/51555102","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Gpwner/article/details/51555102" target="_blank" title="浅谈mysql中子查询">
		<h4 class="text-truncate oneline">
				浅谈<em>mysql</em>中子<em>查询</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-01</span>
				<span class="read-num hover-hide">
					阅读数 
					4185</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Gpwner/article/details/51555102" target="_blank" title="浅谈mysql中子查询">
				<span class="desc oneline">当一个查询是另一个查询的条件时，称之为子查询。子查询可以使用几个简单命令构造功能强大的复合命令。子查询最常用于SELECT-SQL命令的WHERE子句中。子查询是一个SELECT语句，它嵌套在一个SE...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Gpwner">来自：	<span class="blog_title"> Gpwner的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/reggergdsg/article/details/79437750","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/reggergdsg/article/details/79437750","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/reggergdsg/article/details/79437750" target="_blank" title="ORACLE中EXISTS和IN进行子查询的区别（工作原理分析）">
		<h4 class="text-truncate oneline">
				ORACLE中EXISTS和IN进行子<em>查询</em>的区别（工作<em>原理</em>分析）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-04</span>
				<span class="read-num hover-hide">
					阅读数 
					1225</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/reggergdsg/article/details/79437750" target="_blank" title="ORACLE中EXISTS和IN进行子查询的区别（工作原理分析）">
				<span class="desc oneline">今天和大家分享一下SQL中2个常见的关键字：EXISTS和IN。这2个关键字很常见，但是区别是什么呢？EXISTS和IN的共同点是都是用来做子查询的。区别如下：1，EXISTS一般用于相关子查询，IN...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/reggergdsg">来自：	<span class="blog_title"> reggergdsg的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/oJiaoZhu123/article/details/79220899","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/oJiaoZhu123/article/details/79220899","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/oJiaoZhu123/article/details/79220899" target="_blank" title="MySQL的LIKE你正确使用了吗？敢不敢恶补一下？">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>的LIKE你正确使用了吗？敢不敢恶补一下？		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-31</span>
				<span class="read-num hover-hide">
					阅读数 
					407</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/oJiaoZhu123/article/details/79220899" target="_blank" title="MySQL的LIKE你正确使用了吗？敢不敢恶补一下？">
				<span class="desc oneline">LIKE的高效使用%xxx%这种方式对于数据量少的时候，我们倒可以随意用，但是数据量大的时候，我们就体验到了查询性能的问题，像老化的车子艰难趴着坡一样，并且这种方式并未使用到索引，而是全表扫描，震ji...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/oJiaoZhu123">来自：	<span class="blog_title"> oJiaoZhu123的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_15037231/article/details/80535795","strategy":"BlogCommendFromBaidu","index":"28"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_15037231/article/details/80535795","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_15037231/article/details/80535795" target="_blank" title="分析为什么mysql中like模糊查询效率低">
		<h4 class="text-truncate oneline">
				分析为什么<em>mysql</em>中like模糊<em>查询</em>效率低		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-01</span>
				<span class="read-num hover-hide">
					阅读数 
					1636</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_15037231/article/details/80535795" target="_blank" title="分析为什么mysql中like模糊查询效率低">
				<span class="desc oneline">分析为什么mysql中like模糊查询效率低2015-11-0400:49 ⁄ 评论数1 ⁄被浏览12215views+相比update和insert，一般查询应该是数据库中操作最频繁的。而在有些应用...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_15037231">来自：	<span class="blog_title"> 斜阳雨陌</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/q343509740/article/details/80602537","strategy":"BlogCommendFromBaidu","index":"29"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/q343509740/article/details/80602537","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/q343509740/article/details/80602537" target="_blank" title="MYSQL过滤数据（六）LIKE | ESCAPE">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>过滤数据（六）LIKE | ESCAPE		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-06</span>
				<span class="read-num hover-hide">
					阅读数 
					2322</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/q343509740/article/details/80602537" target="_blank" title="MYSQL过滤数据（六）LIKE | ESCAPE">
				<span class="desc oneline">LIKE操作符常用于模式匹配查询数据。以正确的方式使用LIKE运算符对于提高查询性能至关重要。LIKE操作符允许您从基于指定的模式选择表中的数据。因此，LIKE操作符经常用于SELECT语句的WHER...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/q343509740">来自：	<span class="blog_title"> 有天你会让我妒忌的.</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Megustas_JJC/article/details/83119589","strategy":"BlogCommendFromBaidu","index":"30"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Megustas_JJC/article/details/83119589","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Megustas_JJC/article/details/83119589" target="_blank" title="Mysql模糊查询like效率，以及更高效的写法">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>模糊<em>查询</em>like效率，以及更高效的写法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-17</span>
				<span class="read-num hover-hide">
					阅读数 
					149</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Megustas_JJC/article/details/83119589" target="_blank" title="Mysql模糊查询like效率，以及更高效的写法">
				<span class="desc oneline">在使用msyql进行模糊查询的时候，很自然的会用到like语句，通常情况下，在数据量小的时候，不容易看出查询的效率，但在数据量达到百万级，千万级的时候，查询的效率就很容易显现出来。这个时候查询的效率就...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Megustas_JJC">来自：	<span class="blog_title"> Megustas_JJC的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_42254088/article/details/81810887","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_42254088/article/details/81810887","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_42254088/article/details/81810887" target="_blank" title="【转】MySQL比like语句更高效的写法">
		<h4 class="text-truncate oneline">
				【转】<em>MySQL</em>比like语句更高效的写法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-18</span>
				<span class="read-num hover-hide">
					阅读数 
					634</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_42254088/article/details/81810887" target="_blank" title="【转】MySQL比like语句更高效的写法">
				<span class="desc oneline">https://blog.csdn.net/wpfphp/article/details/52584232https://blog.csdn.net/shellching/article/detail...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_42254088">来自：	<span class="blog_title"> 风居住的街道</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Wuhaotian1996/article/details/80469353","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Wuhaotian1996/article/details/80469353","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Wuhaotian1996/article/details/80469353" target="_blank" title="mysql组合索引like问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em>组合索引like问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-27</span>
				<span class="read-num hover-hide">
					阅读数 
					1250</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Wuhaotian1996/article/details/80469353" target="_blank" title="mysql组合索引like问题">
				<span class="desc oneline">首先我们知道LIKE中只有把百分号放在查询右边才会用到索引如图所示：看到了这个type=range就让我们想起了区间范围查询 范围查询之后的复合查询都会失效如图所示：把其中三个字段设置成复合索引（组合...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Wuhaotian1996">来自：	<span class="blog_title"> Wuhaotian1996的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30342827/article/details/97784134","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30342827/article/details/97784134","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30342827/article/details/97784134" target="_blank" title="MySQL比like语句更高效的写法locate position instr find_in_set">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>比like语句更高效的写法locate position instr find_in_set		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-09</span>
				<span class="read-num hover-hide">
					阅读数 
					6</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30342827/article/details/97784134" target="_blank" title="MySQL比like语句更高效的写法locate position instr find_in_set">
				<span class="desc oneline">使用内部函数instr，可代替传统的like方式查询，并且速度更快。instr函数，第一个参数是字段，第二个参数是要查询的串，返回串的位置，第一个是1，如果没找到就是0.例如，selectnamefr...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30342827">来自：	<span class="blog_title"> weixin_30342827的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/haochunting1984/article/details/84532235","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/haochunting1984/article/details/84532235","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/haochunting1984/article/details/84532235" target="_blank" title="mysql 高效模糊查询 代替like">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 高效模糊<em>查询</em> 代替like		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-27</span>
				<span class="read-num hover-hide">
					阅读数 
					635</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/haochunting1984/article/details/84532235" target="_blank" title="mysql 高效模糊查询 代替like">
				<span class="desc oneline">使用下面的函数来进行模糊查询，如果出现的位置〉0，表示包含该字符串。查询效率比like要高。如果：table.fieldlike '%AAA%'可以改为locate('AAA',table.field...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/haochunting1984">来自：	<span class="blog_title"> baalwolf</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_15807167/article/details/75041642","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_15807167/article/details/75041642","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_15807167/article/details/75041642" target="_blank" title="MySql-LIKE用法">
		<h4 class="text-truncate oneline">
				<em>MySql</em>-LIKE用法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-12</span>
				<span class="read-num hover-hide">
					阅读数 
					2171</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_15807167/article/details/75041642" target="_blank" title="MySql-LIKE用法">
				<span class="desc oneline">模糊匹配%代表任意多个字符_代表一个字符在MySQL中，SQL的模式缺省是忽略大小写的正则模式使用REGEXP和NOTREGEXP操作符。1.“.”匹配任何单个的字符。一个字符类2.“［…］”匹配在方...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_15807167">来自：	<span class="blog_title"> 细心程度决定你的成败</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/yk19851111/article/details/51316071","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/yk19851111/article/details/51316071","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yk19851111/article/details/51316071" target="_blank" title="数据库原理">
		<h4 class="text-truncate oneline">
				数据库<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-04</span>
				<span class="read-num hover-hide">
					阅读数 
					914</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yk19851111/article/details/51316071" target="_blank" title="数据库原理">
				<span class="desc oneline">一提到关系型数据库，我禁不住想：有些东西被忽视了。关系型数据库无处不在，而且种类繁多，从小巧实用的SQLite到强大的Teradata。但很少有文章讲解数据库是如何工作的。你可以自己谷歌/百度一下『关...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yk19851111">来自：	<span class="blog_title"> HugeStaff</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/y20_20/article/details/92695147","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/y20_20/article/details/92695147","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/y20_20/article/details/92695147" target="_blank" title="数据库查询（数据库原理8）">
		<h4 class="text-truncate oneline">
				数据库<em>查询</em>（数据库<em>原理</em>8）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-18</span>
				<span class="read-num hover-hide">
					阅读数 
					95</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/y20_20/article/details/92695147" target="_blank" title="数据库查询（数据库原理8）">
				<span class="desc oneline">数据库查询目录一、select查询语法二、简单查询三、分组和汇总四、连接查询五、子查询六、其他查询七、在数据操作中使用select子句一、select查询语法......</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/y20_20">来自：	<span class="blog_title"> 小人物</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sD7O95O/article/details/78096666","strategy":"BlogCommendFromBaidu","index":"38"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sD7O95O/article/details/78096666","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sD7O95O/article/details/78096666" target="_blank" title="深入浅出数据库索引原理">
		<h4 class="text-truncate oneline">
				深入浅出数据库索引<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-02</span>
				<span class="read-num hover-hide">
					阅读数 
					157</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sD7O95O/article/details/78096666" target="_blank" title="深入浅出数据库索引原理">
				<span class="desc oneline">前段时间，公司一个新上线的网站出现页面响应速度缓慢的问题，一位负责这个项目的但并不是搞技术的妹子找到我，让我想办法提升网站的访问速度，因为已经有很多用户来投诉了。我第一反应觉的是数据库上的问题，假装思...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sD7O95O">来自：	<span class="blog_title"> dotNET跨平台</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhang1206214477/article/details/46548713","strategy":"BlogCommendFromBaidu","index":"39"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhang1206214477/article/details/46548713","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhang1206214477/article/details/46548713" target="_blank" title="关系型数据库的内外连接">
		<h4 class="text-truncate oneline">
				关系型数据库的内外连接		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-18</span>
				<span class="read-num hover-hide">
					阅读数 
					454</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhang1206214477/article/details/46548713" target="_blank" title="关系型数据库的内外连接">
				<span class="desc oneline">内连接：指连接结果仅包含符合连接条件的行，参与连接的两个表都应该符合连接条件。（典型的联接运算，使用像= 或之类的比较运算符）。包括相等联接和自然联接。    内联接使用比较运算符根据每个表共有的列的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhang1206214477">来自：	<span class="blog_title"> zhang1206214477的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaomingdetianxia/article/details/72475924","strategy":"BlogCommendFromBaidu","index":"40"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaomingdetianxia/article/details/72475924","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaomingdetianxia/article/details/72475924" target="_blank" title="面试常考知识点—数据库">
		<h4 class="text-truncate oneline">
				面试常考知识点—数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-18</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaomingdetianxia/article/details/72475924" target="_blank" title="面试常考知识点—数据库">
				<span class="desc oneline">1.存储过程是什么？我们常用的关系型数据库是MySQL，操作数据库的语言一般为SQL语句，SQL在执行的时候需要要先编译，然后执行，而存储过程（StoredProcedure）是一组为了完成某种特定功...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaomingdetianxia">来自：	<span class="blog_title"> wmingstar</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wtyicy/article/details/79602053","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wtyicy/article/details/79602053","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wtyicy/article/details/79602053" target="_blank" title="数据库原理之数据查询（一）（第14天）">
		<h4 class="text-truncate oneline">
				数据库<em>原理</em>之数据<em>查询</em>（一）（第14天）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-19</span>
				<span class="read-num hover-hide">
					阅读数 
					202</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wtyicy/article/details/79602053" target="_blank" title="数据库原理之数据查询（一）（第14天）">
				<span class="desc oneline">前面我写了添加数据的语句，，时间过得真快，马上就过了两个月了，厚积薄发今天开始学习数据的查询，顺表复习，一下以前的一、查询语句  SQLserver提供了SELECT语句用于进行数据库的查询，该语句具...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wtyicy">来自：	<span class="blog_title"> Java学习之乐的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangcanyan/article/details/51439012","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangcanyan/article/details/51439012","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangcanyan/article/details/51439012" target="_blank" title="数据库的原理，一篇文章搞定（一）">
		<h4 class="text-truncate oneline">
				数据库的<em>原理</em>，一篇文章搞定（一）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangcanyan/article/details/51439012" target="_blank" title="数据库的原理，一篇文章搞定（一）">
				<span class="desc oneline">一提到关系型数据库，我禁不住想：有些东西被忽视了。关系型数据库无处不在，而且种类繁多，从小巧实用的SQLite到强大的Teradata。但很少有文章讲解数据库是如何工作的。你可以自己谷歌/百度一下『关...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangcanyan">来自：	<span class="blog_title"> zhangcanyan的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangcanyan/article/details/51439021","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangcanyan/article/details/51439021","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangcanyan/article/details/51439021" target="_blank" title="数据库的原理，一篇文章搞定（二）">
		<h4 class="text-truncate oneline">
				数据库的<em>原理</em>，一篇文章搞定（二）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					9110</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangcanyan/article/details/51439021" target="_blank" title="数据库的原理，一篇文章搞定（二）">
				<span class="desc oneline">客户端管理器客户端管理器是处理客户端通信的。客户端可以是一个（网站）服务器或者一个最终用户或最终应用。客户端管理器通过一系列知名的API（JDBC,ODBC,OLE-DB…）提供不同的方式来访问数据库...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangcanyan">来自：	<span class="blog_title"> zhangcanyan的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34120274/article/details/93314549","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34120274/article/details/93314549","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34120274/article/details/93314549" target="_blank" title="标准sql执行顺序">
		<h4 class="text-truncate oneline">
				标准sql<em>执行</em>顺序		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-04</span>
				<span class="read-num hover-hide">
					阅读数 
					1</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34120274/article/details/93314549" target="_blank" title="标准sql执行顺序">
				<span class="desc oneline">　　1:form组装来自不同表的数据，如formuser或者，formuserasujoingoodsOrderasronu.id=r.userid　　2:where过滤符合查询条件的数据，如：id&amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34120274">来自：	<span class="blog_title"> weixin_34120274的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/z774884795/article/details/84065527","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/z774884795/article/details/84065527","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/z774884795/article/details/84065527" target="_blank" title="（数据库一）数据库基础">
		<h4 class="text-truncate oneline">
				（数据库一）数据库基础		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-14</span>
				<span class="read-num hover-hide">
					阅读数 
					2884</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/z774884795/article/details/84065527" target="_blank" title="（数据库一）数据库基础">
				<span class="desc oneline">一、数据库的发展史  (1)手工管理:藏书阁，图书馆。     优点:分类管理，直观性强     缺点:信息流动慢，不方便  (2)文件管理:计算机文件系统，图书管理系统     优点：分类管理，层次...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/z774884795">来自：	<span class="blog_title"> z774884795的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/csweier/article/details/9196633","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/csweier/article/details/9196633","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/csweier/article/details/9196633" target="_blank" title="数据库select工作原理">
		<h4 class="text-truncate oneline">
				数据库select工作<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1046</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/csweier/article/details/9196633" target="_blank" title="数据库select工作原理">
				<span class="desc oneline">select在数据库中的工作原理。B/S架构中最经典的话题无非于三层架构，可以大概分为数据层，业务逻辑层和表示层，而数据层的作用一般都是和数据库交互，例如查询记录。我们经常是写好查询SQL，然后调用程...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/csweier">来自：	<span class="blog_title"> 天道酬勤，勤能补拙</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/mss359681091/article/details/54894646","strategy":"BlogCommendFromBaidu","index":"47"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/mss359681091/article/details/54894646","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/mss359681091/article/details/54894646" target="_blank" title="Sql查询原理与Select执行顺序（详细）">
		<h4 class="text-truncate oneline">
				Sql<em>查询</em><em>原理</em>与Select<em>执行</em>顺序（详细）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-06</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/mss359681091/article/details/54894646" target="_blank" title="Sql查询原理与Select执行顺序（详细）">
				<span class="desc oneline">原文地址：点击打开链接一切都是为了性能，一切都是为了业务一、查询的逻辑执行顺序(1)FROMleft_table(3)join_typeJOINright_table(2)ONjoin_conditi...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/mss359681091">来自：	<span class="blog_title"> 李赛赛的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/liuxunfeng316/article/details/38386003","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/liuxunfeng316/article/details/38386003","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liuxunfeng316/article/details/38386003" target="_blank" title="MySql体系结构">
		<h4 class="text-truncate oneline">
				<em>MySql</em>体系结构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-05</span>
				<span class="read-num hover-hide">
					阅读数 
					268</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liuxunfeng316/article/details/38386003" target="_blank" title="MySql体系结构">
				<span class="desc oneline">了解MySql必须牢牢记住其体系结构图，Mysql是由SQL接口，解析器，优化器，缓存，存储引擎组成的  1Connectors指的是不同语言中与SQL的交互 2ManagementServeices...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liuxunfeng316">来自：	<span class="blog_title"> liuxunfeng316的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zqchina1/article/details/83928981","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zqchina1/article/details/83928981","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zqchina1/article/details/83928981" target="_blank" title="MySQL 储存原理">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 储存<em>原理</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-10</span>
				<span class="read-num hover-hide">
					阅读数 
					713</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zqchina1/article/details/83928981" target="_blank" title="MySQL 储存原理">
				<span class="desc oneline">https://blog.csdn.net/kimboyang/article/details/79151674</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zqchina1">来自：	<span class="blog_title"> zqchina1的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/OtDaQgzsNC1lZHUO0O0O.html" target="_blank">
                        人工智能原理视频教程</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtTaIgysMDktZWR1.html" target="_blank">
                        区块链原理学习</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/li563868273">
              <img src="https://avatar.csdn.net/6/0/9/3_li563868273.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/11.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/li563868273"  class="" id="uid">li563868273</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="149">
                        <dt><a href="https://blog.csdn.net/li563868273?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/li563868273?t=1"><span class="count">149</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="38">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">38</span></dd>
        </dl>
        <dl class="text-center" title="173">
            <dt>喜欢</dt>
            <dd><span class="count">173</span></dd>
        </dl>
        <dl class="text-center" title="34">
            <dt>评论</dt>
            <dd><span class="count">34</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="5级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-5"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="233370">
                23万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="3719">
                3719            </dd>
        </dl>
        <dl title="15593">
            <dt>排名：</dt>
            <dd>1万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="专栏达人">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/zhuanlan.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/zhuanlan.svg" alt="">
                                   <p>专栏达人</p>
                               </div>
                               <div class="right-box">
                                   授予成功创建个人博客专栏的用户。专栏中添加五篇以上博文即可点亮！撰写博客专栏浓缩技术精华，专栏达人就是你！                               </div>
                           </div>
                       </div>
                   </div>
                                                             <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/li563868273">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/li563868273/article/details/81143764" target="_blank" >
                                        面试官所认为的单例模式                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/li563868273/article/details/81074259" target="_blank" >
                                        异步化，你的高并发大杀器                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/li563868273/article/details/80994180" target="_blank" >
                                        你的项目应该如何正确分层？                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/li563868273/article/details/80979565" target="_blank" >
                                        【战雷系列】再见！SimpleDateFormat                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/li563868273/article/details/80935089" target="_blank" >
                                        【青铜到王者】算法晋级之路                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideColumn" class="aside-box">
    <h3 class="aside-title">博主专栏</h3>
    <div class="aside-content">
        <ul class="column-box csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_520"}' >
                            <li class="clearfix">
                    <div class="img-box float-left">
                        <a class="d-flex align-items-center" href="https://blog.csdn.net/li563868273/column/info/24506">
                            <img src="//img-blog.csdn.net/20180705003004710?imageView2/5/w/120/h/120" alt="">
                        </a>
                    </div>
                    <div class="info">
                        <p class="title"><a href="https://blog.csdn.net/li563868273/column/info/24506">java升级之路</a></p>
                        <div class="data">文章数：<span class="count">4 篇</span> 访问量：<span>2118</span></div>
                    </div>
                </li>
                            <li class="clearfix">
                    <div class="img-box float-left">
                        <a class="d-flex align-items-center" href="https://blog.csdn.net/li563868273/column/info/24613">
                            <img src="//img-blog.csdn.net/20180708152410445?imageView2/5/w/120/h/120" alt="">
                        </a>
                    </div>
                    <div class="info">
                        <p class="title"><a href="https://blog.csdn.net/li563868273/column/info/24613">战雷系列</a></p>
                        <div class="data">文章数：<span class="count">1 篇</span> 访问量：<span>286</span></div>
                    </div>
                </li>
                    </ul>
    </div>
    </div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/5964843">
                    <span class="title oneline">java-并发</span>
                    <span class="count float-right">16篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/5970255">
                    <span class="title oneline">jersey-rest</span>
                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/5972515">
                    <span class="title oneline">java虚拟机之路</span>
                    <span class="count float-right">18篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/5983797">
                    <span class="title oneline">hibernate</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/5984177">
                    <span class="title oneline">Spring</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6001101">
                    <span class="title oneline">Servlet</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6001667">
                    <span class="title oneline">面试笔试题</span>
                    <span class="count float-right">32篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6001695">
                    <span class="title oneline">jwt</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6012167">
                    <span class="title oneline">redis</span>
                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6061133">
                    <span class="title oneline">算法(第4版)</span>
                    <span class="count float-right">11篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6114347">
                    <span class="title oneline">tomcat</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6140962">
                    <span class="title oneline">mybatis</span>
                    <span class="count float-right">16篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6151342">
                    <span class="title oneline">海量数据处理</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6153049">
                    <span class="title oneline">spring MVC</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6156499">
                    <span class="title oneline">mysql</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6177511">
                    <span class="title oneline">网络</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6196725">
                    <span class="title oneline">CXF系列</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6205903">
                    <span class="title oneline">linux</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6231893">
                    <span class="title oneline">leetcode</span>
                    <span class="count float-right">18篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6250356">
                    <span class="title oneline">python</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6345726">
                    <span class="title oneline">storm/jstorm</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6352531">
                    <span class="title oneline">docker</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/6358510">
                    <span class="title oneline">netty</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/7778321">
                    <span class="title oneline">日志</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/li563868273/article/category/7778409">
                    <span class="title oneline">其他心得</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2018/07">
                    2018年7月                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/08">
                    2016年8月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/07">
                    2016年7月                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/06">
                    2016年6月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/05">
                    2016年5月                    <span class="count float-right">23篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/04">
                    2016年4月                    <span class="count float-right">49篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/03">
                    2016年3月                    <span class="count float-right">26篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/02">
                    2016年2月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2016/01">
                    2016年1月                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2015/12">
                    2015年12月                    <span class="count float-right">13篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2015/11">
                    2015年11月                    <span class="count float-right">25篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/li563868273/article/month/2015/03">
                    2015年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/li563868273/article/details/51277399" >
                                                Linux-SHELL中sh和bash的区别                    </a>
					<p class="read">阅读数 <span>24830</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/li563868273/article/details/50277359" >
                                                jwt(json-web-token)在rest中的实现--jersey                    </a>
					<p class="read">阅读数 <span>22978</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/li563868273/article/details/50038653" >
                                                JPA注解主键生成策略-UUID                    </a>
					<p class="read">阅读数 <span>19123</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/li563868273/article/details/51472269" >
                                                redis-命令返回值                    </a>
					<p class="read">阅读数 <span>8952</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/li563868273/article/details/52010695" >
                                                Jackson和FastJson性能谁更快                    </a>
					<p class="read">阅读数 <span>8762</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/li563868273/article/details/81074259#comments">异步化，你的高并发大杀器</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/familyshizhouna" class="user-name" target="_blank">familyshizhouna：</a>这点阅读数不合理啊                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/li563868273/article/details/81074259#comments">异步化，你的高并发大杀器</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/u013034226" class="user-name" target="_blank">u013034226：</a>硬着头皮看完了。                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/li563868273/article/details/51200876#comments">各种排序的比较和使用场景分析</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/u013034226" class="user-name" target="_blank">u013034226：</a>[reply]hjs845235536[/reply]
666                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/li563868273/article/details/51200876#comments">各种排序的比较和使用场景分析</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/u013034226" class="user-name" target="_blank">u013034226：</a>哈哈                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/li563868273/article/details/81074259#comments">异步化，你的高并发大杀器</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/liuzhigang828" class="user-name" target="_blank">liuzhigang828：</a>牛逼啊                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">3</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/li563868273/article/details/51254110" title="MySql查询方式优化-重新构建查询">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/li563868273/article/details/51263501" title="利用CXF开发SOAP插件">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/li563868273/article/details/51254110" title="MySql查询方式优化-重新构建查询">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/li563868273/article/details/51263501" title="利用CXF开发SOAP插件">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "51254907";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/li563868273/article/details/51254907";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "Mysql执行查询的原理 - lizhao007";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = 'atom-one-dark';
	var highlight = ["mysql","\u6267\u884c","\u67e5\u8be2","\u539f\u7406"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-dark.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
